// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_ORDER
// * CreateDate    : 2011/9/27 11:24:18
// * Creater       : CodeSmith
// * LastChangeDate: 2011/9/27 11:24:18
// * LastChanger   : 2011/9/27 11:24:18
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesOrderTable : TableInfo
    {
		public const string C_TableName = "SALES_ORDER";
		
		public const string C_ORDER_ID = "ORDER_ID";
		public const string C_QUOTE_ORDER_ID = "QUOTE_ORDER_ID";
		public const string C_SUPPLIER_ID = "SUPPLIER_ID";
		public const string C_CONTACT_ID = "CONTACT_ID";
		public const string C_CUSTOMER_ID = "CUSTOMER_ID";
		public const string C_ORDER_CODE = "ORDER_CODE";
		public const string C_ORDER_DEPARTMENT = "ORDER_DEPARTMENT";
		public const string C_ORDER_PERSON = "ORDER_PERSON";
		public const string C_DELIVERY_DATE = "DELIVERY_DATE";
		public const string C_TOTAL_AMOUNT = "TOTAL_AMOUNT";
		public const string C_CURRENCY = "CURRENCY";
		public const string C_TRANSPORT_TYPE = "TRANSPORT_TYPE";
		public const string C_PACKAGE_TYPE = "PACKAGE_TYPE";
		public const string C_ORDER_DATE = "ORDER_DATE";
		public const string C_PAYMENT_TYPE = "PAYMENT_TYPE";
		public const string C_REMARK = "REMARK";
		public const string C_IS_TAX = "IS_TAX";
        public const string C_IS_EFFECTIVE = "IS_EFFECTIVE";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
		public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
		public const string C_APPROVED_DATE = "APPROVED_DATE";
		public const string C_APPROVED_BY = "APPROVED_BY";
		public const string C_ATTACHMENT = "ATTACHMENT";
        public const string C_STATUS = "STATUS";
        		
		public SalesOrderTable()
        {
            _tableName = "SALES_ORDER";
        }
		
		protected static SalesOrderTable _current;
        public static SalesOrderTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesOrderTable();

            _current.Add(C_ORDER_ID, new ColumnInfo(C_ORDER_ID,"OrderId", true, typeof(string)));
            _current.Add(C_QUOTE_ORDER_ID, new ColumnInfo(C_QUOTE_ORDER_ID,"QuoteOrderId", false, typeof(string)));
            _current.Add(C_SUPPLIER_ID, new ColumnInfo(C_SUPPLIER_ID,"SupplierId", false, typeof(string)));
            _current.Add(C_CONTACT_ID, new ColumnInfo(C_CONTACT_ID,"ContactId", false, typeof(string)));
            _current.Add(C_CUSTOMER_ID, new ColumnInfo(C_CUSTOMER_ID,"CustomerId", false, typeof(string)));
            _current.Add(C_ORDER_CODE, new ColumnInfo(C_ORDER_CODE,"OrderCode", false, typeof(string)));
            _current.Add(C_ORDER_DEPARTMENT, new ColumnInfo(C_ORDER_DEPARTMENT,"OrderDepartment", false, typeof(string)));
            _current.Add(C_ORDER_PERSON, new ColumnInfo(C_ORDER_PERSON,"OrderPerson", false, typeof(string)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE,"DeliveryDate", false, typeof(DateTime)));
            _current.Add(C_TOTAL_AMOUNT, new ColumnInfo(C_TOTAL_AMOUNT,"TotalAmount", false, typeof(decimal)));
            _current.Add(C_CURRENCY, new ColumnInfo(C_CURRENCY,"Currency", false, typeof(string)));
            _current.Add(C_TRANSPORT_TYPE, new ColumnInfo(C_TRANSPORT_TYPE,"TransportType", false, typeof(string)));
            _current.Add(C_PACKAGE_TYPE, new ColumnInfo(C_PACKAGE_TYPE,"PackageType", false, typeof(string)));
            _current.Add(C_ORDER_DATE, new ColumnInfo(C_ORDER_DATE,"OrderDate", false, typeof(DateTime)));
            _current.Add(C_PAYMENT_TYPE, new ColumnInfo(C_PAYMENT_TYPE,"PaymentType", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_IS_TAX, new ColumnInfo(C_IS_TAX,"IsTax", false, typeof(int)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE,"LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY,"LastModifiedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE,"ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY,"ApprovedBy", false, typeof(string)));
            _current.Add(C_ATTACHMENT, new ColumnInfo(C_ATTACHMENT,"Attachment", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_IS_EFFECTIVE, new ColumnInfo(C_IS_EFFECTIVE, "IsEffective", false, typeof(int)));
			
		}
		
		public ColumnInfo ORDER_ID
        {
            get { return this[C_ORDER_ID]; }
        }
		
		public ColumnInfo QUOTE_ORDER_ID
        {
            get { return this[C_QUOTE_ORDER_ID]; }
        }
		
		public ColumnInfo SUPPLIER_ID
        {
            get { return this[C_SUPPLIER_ID]; }
        }
		
		public ColumnInfo CONTACT_ID
        {
            get { return this[C_CONTACT_ID]; }
        }
		
		public ColumnInfo CUSTOMER_ID
        {
            get { return this[C_CUSTOMER_ID]; }
        }
		
		public ColumnInfo ORDER_CODE
        {
            get { return this[C_ORDER_CODE]; }
        }
		
		public ColumnInfo ORDER_DEPARTMENT
        {
            get { return this[C_ORDER_DEPARTMENT]; }
        }
		
		public ColumnInfo ORDER_PERSON
        {
            get { return this[C_ORDER_PERSON]; }
        }
		
		public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }
		
		public ColumnInfo TOTAL_AMOUNT
        {
            get { return this[C_TOTAL_AMOUNT]; }
        }
		
		public ColumnInfo CURRENCY
        {
            get { return this[C_CURRENCY]; }
        }
		
		public ColumnInfo TRANSPORT_TYPE
        {
            get { return this[C_TRANSPORT_TYPE]; }
        }
		
		public ColumnInfo PACKAGE_TYPE
        {
            get { return this[C_PACKAGE_TYPE]; }
        }
		
		public ColumnInfo ORDER_DATE
        {
            get { return this[C_ORDER_DATE]; }
        }
		
		public ColumnInfo PAYMENT_TYPE
        {
            get { return this[C_PAYMENT_TYPE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo IS_TAX
        {
            get { return this[C_IS_TAX]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }
		
		public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }
		
		public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }
		
		public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }
		
		public ColumnInfo ATTACHMENT
        {
            get { return this[C_ATTACHMENT]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo IS_EFFECTIVE
        {
            get { return this[C_IS_EFFECTIVE]; }
        }
		
	}
}

